DROP TABLE CRST_HR_ALL_POSITIONS_F;

CREATE TABLE CRST_HR_ALL_POSITIONS_F
(
POSITION_ID                 NUMBER (15), 
EFFECTIVE_START_DATE        DATE 
EFFECTIVE_END_DATE          DATE 
AVAILABILITY_STATUS_ID      NUMBER (15), 
BUSINESS_GROUP_ID           NUMBER (15), 
ENTRY_GRADE_ID              NUMBER (15), 
ENTRY_GRADE_RULE_ID         NUMBER (15), 
ENTRY_STEP_ID               NUMBER (15), 
JOB_ID                      NUMBER (15), 
LOCATION_ID                 NUMBER (15), 
ORGANIZATION_ID             NUMBER (15), 
PAY_BASIS_ID                NUMBER (9), 
PAY_FREQ_PAYROLL_ID         NUMBER (15), 
POSITION_DEFINITION_ID      NUMBER (15), 
POSITION_TRANSACTION_ID     NUMBER (15), 
PRIOR_POSITION_ID           NUMBER (15), 
RELIEF_POSITION_ID          NUMBER (15), 
SUCCESSOR_POSITION_ID       NUMBER (15), 
SUPERVISOR_ID               NUMBER (10), 
SUPERVISOR_POSITION_ID      NUMBER (15), 
AMENDMENT_DATE              DATE 
AMENDMENT_RECOMMENDATION    VARCHAR (2000), 
AMENDMENT_REF_NUMBER        VARCHAR (30), 
AVAIL_STATUS_PROP_END_DATE  DATE 
BARGAINING_UNIT_CD          VARCHAR (30), 
COMMENTS                    LONG 
COPIED_TO_OLD_TABLE_FLAG    VARCHAR (30), 
CURRENT_JOB_PROP_END_DATE   DATE 
CURRENT_ORG_PROP_END_DATE   DATE 
DATE_EFFECTIVE              DATE 
DATE_END                    DATE 
EARLIEST_HIRE_DATE          DATE 
FILL_BY_DATE                DATE 
FREQUENCY                   VARCHAR (30), 
FTE                         NUMBER (10,2), 
MAX_PERSONS                 NUMBER (4), 
NAME                        VARCHAR (240), 
OVERLAP_PERIOD              NUMBER (22,2), 
OVERLAP_UNIT_CD             VARCHAR (30), 
PAY_TERM_END_DAY_CD         VARCHAR (30), 
PAY_TERM_END_MONTH_CD       VARCHAR (30), 
PERMANENT_TEMPORARY_FLAG    VARCHAR (30), 
PERMIT_RECRUITMENT_FLAG     VARCHAR (30), 
POSITION_TYPE               VARCHAR (30), 
POSTING_DESCRIPTION         VARCHAR (2000), 
PROBATION_PERIOD            NUMBER (22,2), 
PROBATION_PERIOD_UNIT_CD    VARCHAR (30), 
PROPOSED_FTE_FOR_LAYOFF     NUMBER (10,2), 
PROPOSED_DATE_FOR_LAYOFF    DATE 
REPLACEMENT_REQUIRED_FLAG   VARCHAR (30), 
REVIEW_FLAG                 VARCHAR (30), 
SEASONAL_FLAG               VARCHAR (30), 
SECURITY_REQUIREMENTS       VARCHAR (2000), 
STATUS                      VARCHAR (30), 
TERM_START_DAY_CD           VARCHAR (30), 
TERM_START_MONTH_CD         VARCHAR (30), 
TIME_NORMAL_FINISH          VARCHAR (5), 
TIME_NORMAL_START           VARCHAR (5), 
UPDATE_SOURCE_CD            VARCHAR (30), 
WORKING_HOURS               NUMBER (22,3), 
WORKS_COUNCIL_APPROVAL_FLAG VARCHAR (30), 
WORK_PERIOD_TYPE_CD         VARCHAR (30), 
WORK_TERM_END_DAY_CD        VARCHAR (30), 
WORK_TERM_END_MONTH_CD      VARCHAR (30), 
INFORMATION1                VARCHAR (150), 
INFORMATION2                VARCHAR (150), 
INFORMATION3                VARCHAR (150), 
INFORMATION4                VARCHAR (150), 
INFORMATION5                VARCHAR (150), 
INFORMATION6                VARCHAR (150), 
INFORMATION7                VARCHAR (150), 
INFORMATION8                VARCHAR (150), 
INFORMATION9                VARCHAR (150), 
INFORMATION10               VARCHAR (150), 
INFORMATION11               VARCHAR (150), 
INFORMATION12               VARCHAR (150), 
INFORMATION13               VARCHAR (150), 
INFORMATION14               VARCHAR (150), 
INFORMATION15               VARCHAR (150), 
INFORMATION16               VARCHAR (150), 
INFORMATION17               VARCHAR (150), 
INFORMATION18               VARCHAR (150), 
INFORMATION19               VARCHAR (150), 
INFORMATION20               VARCHAR (150), 
INFORMATION21               VARCHAR (150), 
INFORMATION22               VARCHAR (150), 
INFORMATION23               VARCHAR (150), 
INFORMATION24               VARCHAR (150), 
INFORMATION25               VARCHAR (150), 
INFORMATION26               VARCHAR (150), 
INFORMATION27               VARCHAR (150), 
INFORMATION28               VARCHAR (150), 
INFORMATION29               VARCHAR (150), 
INFORMATION30               VARCHAR (150), 
INFORMATION_CATEGORY        VARCHAR (30), 
ATTRIBUTE1                  VARCHAR (150), 
ATTRIBUTE2                  VARCHAR (150), 
ATTRIBUTE3                  VARCHAR (150), 
ATTRIBUTE4                  VARCHAR (150), 
ATTRIBUTE5                  VARCHAR (150), 
ATTRIBUTE6                  VARCHAR (150), 
ATTRIBUTE7                  VARCHAR (150), 
ATTRIBUTE8                  VARCHAR (150), 
ATTRIBUTE9                  VARCHAR (150), 
ATTRIBUTE10                 VARCHAR (150), 
ATTRIBUTE11                 VARCHAR (150), 
ATTRIBUTE12                 VARCHAR (150), 
ATTRIBUTE13                 VARCHAR (150), 
ATTRIBUTE14                 VARCHAR (150), 
ATTRIBUTE15                 VARCHAR (150), 
ATTRIBUTE16                 VARCHAR (150), 
ATTRIBUTE17                 VARCHAR (150), 
ATTRIBUTE18                 VARCHAR (150), 
ATTRIBUTE19                 VARCHAR (150), 
ATTRIBUTE20                 VARCHAR (150), 
ATTRIBUTE21                 VARCHAR (150), 
ATTRIBUTE22                 VARCHAR (150), 
ATTRIBUTE23                 VARCHAR (150), 
ATTRIBUTE24                 VARCHAR (150), 
ATTRIBUTE25                 VARCHAR (150), 
ATTRIBUTE26                 VARCHAR (150), 
ATTRIBUTE27                 VARCHAR (150), 
ATTRIBUTE28                 VARCHAR (150), 
ATTRIBUTE29                 VARCHAR (150), 
ATTRIBUTE30                 VARCHAR (150), 
ATTRIBUTE_CATEGORY          VARCHAR (30), 
REQUEST_ID                  NUMBER (15), 
PROGRAM_APPLICATION_ID      NUMBER (15), 
PROGRAM_ID                  NUMBER (15), 
PROGRAM_UPDATE_DATE         DATE, 
CREATED_BY                  NUMBER (15), 
CREATION_DATE               DATE, 
LAST_UPDATED_BY             NUMBER (15), 
LAST_UPDATE_DATE            DATE, 
LAST_UPDATE_LOGIN           NUMBER (15), 
OBJECT_VERSION_NUMBER       NUMBER (9)

);
